package Configurations;

/* Configure constants related to MySQL databases */
public class MySQL {

    /* Location of your databases for this application. For NetBeans click the
     * Services tab on the left, expand the Database navigator, right click the
     * appropriate database, click properties and the second field contains the
     * Database URL.
     */
    public static final String DB_URL = "jdbc:mysql://localhost:3306/graduate application system";
    /* Driver used by java to connect to MySQL*/
    public static final String DB_DRIVER = "com.mysql.jdbc.Driver";
    /* Name of the MySQL database user*/
    public static final String DB_USER = "root";
    /* Corresponding password for the MySQL database user */
    public static final String DB_PASS = "hello";
    /* Name of the database containing user login information */
    public static final String DB_LOGIN = "logins";
    /* Name of the database containing official test score information */
    public static final String DB_SCORES = "scores";
    /* Name of the database containing application information (AY Files) */
    public static final String DB_APPS = "applications";
    /* Name of the database containing ratings and reviews */
    public static final String DB_REVS = "reviews";
    /* The following is for mapping column names in your login database that
     * correspond to a specific purpose.
     */
    /* Column for storing usernames (LONGVARCHAR)*/
    public static final String DB_LOGIN_USERNAME = "username";
    /* Column for storing passwords (LONGVARCHAR) */
    public static final String DB_LOGIN_PASSWORD = "password";
    /* Column for indicating whether a user is a chair person (TINYINT) */
    public static final String DB_LOGIN_ISCHAIR = "isChair";
    /* Column for storing emails (TEXT) */
    public static final String DB_LOGIN_EMAIL = "email";
    /* Column for storing expert countries seperated by commas (TEXT) */
    public static final String DB_LOGIN_CNTRY = "expertCountry";
    /* Column for storing expert research topics esperated by commas (TEXT) */
    public static final String DB_LOGIN_RSRCH = "expertResearch";
    /* Column for storing number of reviews assigned so far this year (INT) */
    public static final String DB_LOGIN_NUMREVIEWS = "numAssignedReviews";
    /* Column for storing availability (TINYINT) */
    public static final String DB_LOGIN_AVAILABLE = "available";
    /* Column for storing workload ratio (REAL) */
    public static final String DB_LOGIN_WORKLOAD = "workload";
    /* Column for storing emails of assigned applications (TEXT) */
    public static final String DB_LOGIN_ASSIGNED = "assigned";

    /* The following is for mapping column names in your application database
     * that correspond to a specific purpose.
     */
    /* Column for storing emails (TEXT) */
    public static final String DB_APPS_EMAIL = "email_address";
    /* Column for storing the first name of applicants (TEXT) */
    public static final String DB_APPS_FIRST = "first_name";
    /* Column for storing the last name of applicants (TEXT) */
    public static final String DB_APPS_LAST = "last_name";
    
    /**
     * The following is for mapping column names in your reviews database that
     * correspond to a specific purpose.
     */
    /* Column for storing the email of the application (TEXT) */
    public static final String DB_REVS_APP_EMAIL = "appEmail";
    /* Column for storing the username of the reviewer (TEXT) */
    public static final String DB_REVS_REV_USER = "reviewerUsername";
    /* Column for storing the rating of the reviewer (TEXT) */
    public static final String DB_REVS_RATING = "rating";
    /* Column for storing the comments of the reviewr (TEXT) */
    public static final String DB_REVS_COMMENTS = "comment";
    
    
    /* The following is for mapping column names in your scores database
     * that correspond to a specific purpsoe.
     */
    /* Column for storing emails (TEXT) */
    public static final String DB_SCORES_EMAIL = "email_address";
    
    /* An instance of this class should never be created */
    private MySQL() {
    }
}
